﻿<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="frmEmpleados.aspx.cs" Inherits="frmEmpleados" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
    <style type="text/css">
        .style3
    {
        
        height: 23px;
     
    }
        .style5
        {
            color: #000000;
            height: 31px;
        }
        .style6
        {
            color: #000000;
            height: 22px;
            width: 987px;
        }
                
        .style39
        {
            position: absolute;
            left: 353px;
            top: 244px;
        }
        
        .style40
        {
            position: absolute;
            left: 285px;
            top: 246px;
        }
        
        .style42
        {
            position: absolute;
            top: 251px;
            left: 211px;
            z-index: 1;
        }
        
        .style44
        {
            position: absolute;
            left: 354px;
            top: 279px;
        }
        
        .style45
        {
            position: absolute;
            left: 282px;
            top: 304px;
        }
        .style46
        {
            position: absolute;
            top: 303px;
            left: 235px;
            z-index: 1;
            width: 40px;
            height: 21px;
        }
        
        .style49
        {
            position: absolute;
            left: 282px;
            top: 355px;
            width: 332px;
        }
        
        .style50
        {
            position: absolute;
            left: 282px;
            top: 381px;
            width: 332px;
            height: 30px;
        }
        .style51
        {
            position: absolute;
            top: 355px;
            left: 223px;
            z-index: 1;
        }
        .style52
        {
            position: absolute;
            top: 385px;
            left: 223px;
            z-index: 1;
        }
        
        .style53
        {
            position: absolute;
            left: 484px;
            top: 419px;
            z-index: 2;
        }
        
        .style54
        {
            position: absolute;
            left: 539px;
            top: 242px;
        }
        .style55
        {
            position: absolute;
            top: 418px;
            left: 380px;
            z-index: 1;
            width: 95px;
        }
        .style56
        {
            position: absolute;
            top: 418px;
            left: 226px;
            z-index: 1;
            height: 18px;
        }
        
        .style58
        {
            position: absolute;
            left: 286px;
            top: 475px;
            width: 288px;
            height: 29px;
        }
        .style59
        {
            position: absolute;
            top: 483px;
            left: 233px;
            z-index: 1;
        }
        .style60
        {
            position: absolute;
            top: 546px;
            left: 234px;
            z-index: 1;
        }
        
        .style61
        {
            position: absolute;
            left: 292px;
            top: 419px;
            width: 67px;
            height: 16px;
        }
        .style62
        {
            position: absolute;
            left: 284px;
            top: 538px;
            width: 286px;
        }
        
        .style64
        {
            position: absolute;
            left: 366px;
            top: 504px;
            width: 204px;
            height: 29px;
        }
        
        .style65
        {
            position: absolute;
            left: 285px;
            top: 507px;
            height: 30px;
        }
        .style66
        {
            position: absolute;
            top: 512px;
            left: 220px;
            z-index: 1;
        }
        
        .style67
        {
            position: absolute;
            left: 258px;
            top: 651px;
        }
        
        .style68
        {
            position: absolute;
            left: 479px;
            top: 651px;
        }
        
        .style69
        {
            position: absolute;
            left: 698px;
            top: 652px;
        }
        
        .style70
        {
            position: absolute;
            left: 917px;
            top: 651px;
        }
        
        .style71
        {
            position: absolute;
            left: 774px;
            top: 505px;
            width: 435px;
        }
        
        .style72
        {
            position: absolute;
            left: 778px;
            top: 250px;
            height: 30px;
        }
        
        .style74
        {
            position: absolute;
            left: 778px;
            top: 284px;
            height: 30px;
        }
        
        .style75
        {
            position: absolute;
            left: 917px;
            top: 283px;
            height: 30px;
        }
        
        .style76
        {
            position: absolute;
            left: 1090px;
            top: 250px;
            height: 30px;
            width: 113px;
        }
        
        .style78
        {
            position: absolute;
            left: 839px;
            top: 163px;
        }
        
        .style79
        {
            position: absolute;
            left: 778px;
            top: 400px;
        }
        
        .style80
        {
            position: absolute;
            left: 778px;
            top: 429px;
        }
        
        .style81
        {
            position: absolute;
            left: 779px;
            top: 370px;
        }
        
        .style82
        {
            position: absolute;
            left: 778px;
            top: 318px;
            height: 30px;
            width: 96px;
        }
        
        .style83
        {
            position: absolute;
            left: 1118px;
            top: 720px;
        }
        .style84
        {
            position: absolute;
            top: 163px;
            left: 781px;
            z-index: 1;
        }
        .style85
        {
            position: absolute;
            top: 256px;
            left: 1065px;
            z-index: 1;
        }
        .style86
        {
            position: absolute;
            top: 290px;
            left: 742px;
            z-index: 1;
            color: #000000;
        }
        .style87
        {
            position: absolute;
            top: 0px;
            left: 0px;
        }
        .style88
        {
            position: absolute;
            top: 292px;
            left: 880px;
            z-index: 1;
            color: #000000;
        }
        .style89
        {
            position: absolute;
            top: 324px;
            left: 709px;
            z-index: 1;
            color: #000000;
        }
        .style90
        {
            position: absolute;
            top: 435px;
            left: 717px;
            z-index: 1;
            color: #000000;
        }
        .style91
        {
            position: absolute;
            top: 403px;
            left: 715px;
            z-index: 1;
            color: #000000;
        }
        .style92
        {
            position: absolute;
            top: 253px;
            left: 740px;
            z-index: 1;
            color: #000000;
        }
        .style93
        {
            position: absolute;
            top: 372px;
            left: 735px;
            z-index: 1;
        }
        .style94
        {
            position: absolute;
            top: 477px;
            left: 699px;
            z-index: 1;
            color: #000000;
        }
        .style95
        {
            position: absolute;
            top: 197px;
            left: 231px;
            z-index: 1;
            width: 175px;
        }
        .style98
        {
            position: absolute;
            top: 198px;
            left: 712px;
            z-index: 1;
            width: 175px;
        }
        
        .style99
        {
            position: absolute;
            left: 202px;
            top: 638px;
            width: 1086px;
            height: 43px;
        }
        .style100
        {
            position: absolute;
            left: 202px;
            top: 187px;
            width: 469px;
            height: 439px;
        }
        .style101
        {
            position: absolute;
            left: 686px;
            top: 187px;
            width: 602px;
            height: 438px;
        }
        .style103
        {
            position: absolute;
            top: 222px;
            left: 264px;
            z-index: 1;
            height: 30px;
            width: 106px;
        }
        .style104
        {
            position: absolute;
            top: 222px;
            left: 77px;
            z-index: 1;
            height: 30px;
            width: 92px;
        }
        .style105
        {
            position: absolute;
            top: 380px;
            left: 79px;
            z-index: 1;
        }
        .style106
        {
            position: absolute;
            top: 73px;
            left: 149px;
            z-index: 1;
        }
                
        .style115
        {
            width: 1126px;
        }
        
        .style116
        {
            width: 1086px;
            height: 42px;
            position: absolute;
            top: 64px;
            left: -22px;
            z-index: 1;
        }
        .style117
        {
            position: absolute;
            top: 56px;
            left: 302px;
            z-index: 1;
        }
        .style118
        {
            position: absolute;
            top: 167px;
            left: 413px;
            z-index: 1;
        }
        .style119
        {
            position: absolute;
            top: 195px;
            left: 414px;
            z-index: 1;
        }
        .style120
        {
            position: absolute;
            top: 352px;
            left: -111px;
            z-index: 1;
        }
        .style121
        {
            position: absolute;
            top: 319px;
            left: 373px;
            z-index: 1;
        }
        .style122
        {
            position: absolute;
            top: 67px;
            left: 365px;
            z-index: 1;
        }
        .style123
        {
            position: absolute;
            top: 67px;
            left: 518px;
            z-index: 1;
        }
        
        </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder2" Runat="Server">
    <h4>Menu</h4>
        <br>
        <p>
        <a href="frmEmpresa.aspx">Empresa</a>
        <br>
        <a href="frmListaDeEstablecimientos.aspx">Establecimientos</a>
        <br>
        <a href="frmContacto.aspx">Contactos</a>
        <br>
        <a href="frmEmpleados.aspx">Empleados</a>
        <br>
      
        </p>
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <h1 class="style115">Administracion de Empleados</h1>
     
                    
                     <strong>
                     <asp:Label ID="Label32" runat="server" CssClass="style95" 
                         Text="Datos Personales"></asp:Label>
                     </strong>
                    
           
       
                     <asp:Label ID="Label33" runat="server" CssClass="style98" Font-Bold="True" 
                         Text="Domicilio"></asp:Label>
            
           
          
                 &nbsp;<strong><asp:Label ID="Label2" runat="server" CssClass="style78"  Text="Label"></asp:Label>
                 <asp:Label ID="Label21" runat="server" CssClass="style84" Text="Fecha"></asp:Label>
                 </strong>
           
             
           
                 <asp:Label ID="Label29" runat="server" CssClass="style92" 
                     Text="Calle"></asp:Label>
            
                     <span class="style5">&nbsp;<asp:DropDownList ID="DropTipoDNI" 
        runat="server"  CssClass="style40" DataSourceID="DSTipoDoc" 
        DataTextField="descripcionTipoDocumento" DataValueField="idTipoDocumento" 
        Height="27px" Width="63px" BackColor="#DDEDEE">
    </asp:DropDownList>
                     &nbsp;<asp:TextBox ID="TBNroDNI" runat="server" 
    CssClass="style39" Width="150px" Height="27px" ValidationGroup="1" 
                         BackColor="#DDEDEE" CausesValidation="True"></asp:TextBox>
     
                     &nbsp;<asp:Button ID="Button2" runat="server" onclick="Button2_Click" 
             Text="Consultar" Height="30px" ValidationGroup="1" CssClass="style54"  Width="90px" />
                    
                     <asp:Label ID="Label12" runat="server" CssClass="style42" 
                         Text="Documento"></asp:Label>
                    
                     </span>
           
                     <span class="style6">&nbsp;&nbsp; </span>
        <asp:TextBox ID="TBCalle" runat="server" Width="276px"  CssClass="style72" 
                         BackColor="#DDEDEE"></asp:TextBox>
             
                 <asp:Label ID="Label23" runat="server" CssClass="style86" 
                     Text="Piso"></asp:Label>
                 <span class="style6">&nbsp;</span><asp:TextBox ID="TBNumCasa" 
        runat="server"  CssClass="style76" 
                     BackColor="#DDEDEE"></asp:TextBox>
                     <span class="style5">
     
                     <asp:Label ID="Label22" runat="server" CssClass="style85" Text="Nro."></asp:Label>
                 <asp:Label ID="Label30" runat="server" CssClass="style93" 
                     Text="Barrio"></asp:Label>
     
                     </span>
                
             <asp:Label ID="Label24" runat="server" CssClass="style87" style="z-index: 1" 
                 Text="Label"></asp:Label>
      
             <td class="style21">
                    
                     <strong>
                    
                     <asp:Label ID="Label3" runat="server" Font-Bold="True" ForeColor="Red" 
                         CssClass="style44" ViewStateMode="Disabled"></asp:Label>
                     &nbsp;</strong></td><td class="style22"><span class="style6">&nbsp;&nbsp;&nbsp; </span>
        <asp:TextBox ID="TBPiso" runat="server" Width="95px" CssClass="style74"  
                         BackColor="#DDEDEE"></asp:TextBox>
        <span class="style6">&nbsp; &nbsp; </span>
        <asp:TextBox ID="TBDpto" runat="server" Width="136px" CssClass="style75"  
                         BackColor="#DDEDEE"></asp:TextBox>
        <span class="style6">&nbsp;</span></td>
             <td class="style23">
                 <span class="style6">&nbsp; </span>
                 <asp:Label ID="Label26" runat="server" CssClass="style89" 
                     Text="Cod.Postal"></asp:Label>
                
       
            
                     &nbsp;&nbsp;&nbsp;<asp:Label ID="Label13" runat="server" CssClass="style46" 
                         Text="Estado" ForeColor="Black"></asp:Label>
&nbsp;<asp:DropDownList ID="DropDownList1" CssClass="style45"  runat="server" 
                         Height="30px" Width="194px" BackColor="#DDEDEE">
                         <asp:ListItem>Activo</asp:ListItem>
                         <asp:ListItem>Inactivo</asp:ListItem>
                     </asp:DropDownList>
                     
           
                 <span class="style6">&nbsp;&nbsp;</span><asp:DropDownList ID="DropProvincia" 
                     runat="server" DataSourceID="DSProvincia" 
            DataTextField="nombreProvincia" DataValueField="idProvincia" 
        Height="29px"  CssClass="style79" 
            Width="271px" BackColor="#DDEDEE">
        </asp:DropDownList>
                    
                   <span class="style6">&nbsp;</span><asp:DropDownList ID="DropLocalidad" 
                         runat="server" DataSourceID="DSLocalidad" 
            DataTextField="nombreLocalidad" DataValueField="idLocalidad" 
        Height="30px"  CssClass="style80" 
            Width="272px" BackColor="#DDEDEE">
        </asp:DropDownList>
                     <asp:Label ID="Label31" runat="server" CssClass="style94" 
                     Text="Observaciones"></asp:Label>
                    
           
                 <asp:Label ID="Label25" runat="server" CssClass="style88" 
                     Text="Dpto."></asp:Label>
                 <asp:Label ID="Label28" runat="server" CssClass="style91" Text="Localidad"></asp:Label>
            
    <asp:TextBox ID="TBNombre" runat="server" CssClass="style49"  Height="27px" 
                         BackColor="#DDEDEE" CausesValidation="True" 
        ValidationGroup="2"></asp:TextBox>
                     &nbsp;&nbsp;<asp:Label ID="Label14" runat="server" CssClass="style51" 
                         ForeColor="Black" Text="Nombre"></asp:Label>
                    
                 <span class="style6">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>
        <asp:DropDownList ID="DropBarrio" runat="server" DataSourceID="DSBarrio"  CssClass="style81" 
            DataTextField="nombreBarrio" DataValueField="idBarrio" Height="31px" 
            Width="270px" BackColor="#DDEDEE">
        </asp:DropDownList>
                    
                 <asp:Label ID="Label27" runat="server" CssClass="style90" Text="Provincia"></asp:Label>
           
                     <span class="style5">&nbsp;<asp:TextBox ID="TBApellido" 
        runat="server" CssClass="style50"  BackColor="#DDEDEE" 
        CausesValidation="True" ValidationGroup="2"></asp:TextBox>
     
                     <asp:Label ID="Label15" runat="server" CssClass="style52" 
                         Text="Apellido"></asp:Label>
     
                     &nbsp;
                     &nbsp;<asp:Label ID="Label11" runat="server" 
                         CssClass="style61" Font-Bold="True" style="z-index: 2"></asp:Label>
                     &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<asp:Label 
        ID="Label17" runat="server" CssClass="style56" Text="Legajo"></asp:Label>
                     &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;
                     <asp:Label ID="Label8" runat="server" CssClass="style53"  
        Font-Bold="True" style="z-index: 3"></asp:Label>
                    
                     <asp:Label ID="Label16" runat="server" CssClass="style55" 
                         Text="Fecha Ingreso"></asp:Label>
     
                     </span>
                     <span class="style5">&nbsp;<asp:Label ID="Label18" runat="server" 
                         CssClass="style59" Text="Cargo"></asp:Label>
                     &nbsp;&nbsp; </span>
    <asp:DropDownList ID="DropCargo" runat="server" DataSourceID="DSCargo"  CssClass="style58" 
        DataTextField="descripcionCargo" DataValueField="idCargo" 
        BackColor="#DDEDEE" CausesValidation="True" ValidationGroup="2">
    </asp:DropDownList>
                    
               
                
        <asp:TextBox ID="TBObservaciones" runat="server" Height="59px"  CssClass="style71" 
            TextMode="MultiLine" BackColor="#DDEDEE"></asp:TextBox>
            
                     <span class="style5">
                     &nbsp;&nbsp;<asp:Label ID="Label19" runat="server" CssClass="style60" 
                         Text="E-Mail"></asp:Label>
                     &nbsp; </span>
    <asp:TextBox ID="TBEmail" runat="server" CssClass="style62"  Height="30px" 
                         BackColor="#DDEDEE" CausesValidation="True" 
        ValidationGroup="2"></asp:TextBox>
                     
                     <asp:DropDownList 
                         ID="DropTipoTel" runat="server" DataSourceID="DSTipoTel" 
        DataTextField="descripcionTipoTelefono" DataValueField="idTipoTelefono"  
        CssClass="style65" Width="78px" BackColor="#DDEDEE">
    </asp:DropDownList>
    <span class="style5">&nbsp;&nbsp; </span>
    <asp:TextBox ID="TBNroTelefono" runat="server" CssClass="style64" 
                         BackColor="#DDEDEE" TextMode="SingleLine"></asp:TextBox>
                    
                     <span class="style5">
     
                     <asp:Label ID="Label20" runat="server" CssClass="style66" Text="Telefono"></asp:Label>
     
                     </span>
                    
               
         <asp:Button ID="Button1" runat="server" onclick="Button1_Click" 
             Text="Registrar Empleado" Height="27px" Width="214px"  CssClass="style67" 
             ValidationGroup="2" Enabled="False" />
         <asp:Button ID="Button4" runat="server" onclick="Button4_Click"  CssClass="style68" 
             Text="Listar Empleados" Height="27px" Width="213px" />
            
                 <asp:Button 
             ID="Button3" runat="server" onclick="Button3_Click" 
        Text="Modificar Datos"  CssClass="style69" 
             Height="27px" Width="213px" Enabled="False" ValidationGroup="2" />
         <asp:Button ID="Button6" runat="server" Height="29px" 
        onclick="Button6_Click"  CssClass="style70" 
             Text="Limpiar Campos" Width="212px" CausesValidation="False" />
             
         <asp:Button ID="Button5" runat="server" Height="30px" onclick="Button5_Click"  CssClass="style83" 
             Text="Regresar" Width="172px" Visible="False" />
             
   
       
        <asp:TextBox ID="TBCodPostal" runat="server"  CssClass="style82" 
                     BackColor="#DDEDEE"></asp:TextBox>
                <b>
                <asp:Panel 
           ID="Panel6" runat="server" BorderStyle="Groove" 
           CssClass="style99">
                    <asp:ValidationSummary ID="ValidationSummary1" runat="server" 
                        CssClass="style116" DisplayMode="SingleParagraph" 
                        HeaderText="Debe Completar los Datos Obligatorios (*)" ShowMessageBox="True" 
                        ShowSummary="False" ValidationGroup="2" />
    </asp:Panel>
       </b>
   
                <b>
                <asp:Panel 
           ID="Panel4" runat="server" BorderStyle="Groove" 
           CssClass="style101">
                    <b>
                    <asp:RequiredFieldValidator ID="RequiredFieldValidator14" 
    runat="server" ControlToValidate="TBNumCasa" 
    CssClass="style123" ErrorMessage="*" ForeColor="Red" ValidationGroup="2"></asp:RequiredFieldValidator>
                    <asp:RequiredFieldValidator ID="RequiredFieldValidator15" runat="server" 
                        ControlToValidate="TBEmail" CssClass="style120" ErrorMessage="*" 
                        ForeColor="Red" ValidationGroup="2"></asp:RequiredFieldValidator>
                    <asp:RequiredFieldValidator ID="RequiredFieldValidator16" runat="server" 
                        ControlToValidate="TBCalle" CssClass="style122" ErrorMessage="*" 
                        ForeColor="Red" ValidationGroup="2"></asp:RequiredFieldValidator>
                    </b>
    </asp:Panel>
                <asp:Panel 
           ID="Panel5" runat="server" BorderStyle="Groove" 
           CssClass="style100">
                    <asp:TextBox ID="TextBox2" runat="server" BackColor="#DDEDEE" 
                        CssClass="style103" Enabled="False"></asp:TextBox>
                    <asp:TextBox ID="TextBox3" runat="server" BackColor="#DDEDEE" 
                        CssClass="style104" Enabled="False"></asp:TextBox>
                    <asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" 
                        ControlToValidate="TBEmail" CssClass="style105" 
                        ErrorMessage="Ingrese E-Mail Valido" Font-Bold="True" ForeColor="Red" 
                        ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*" 
                        ValidationGroup="2"></asp:RegularExpressionValidator>
                    <asp:RangeValidator ID="RangeValidator1" runat="server" 
                        ControlToValidate="TBNroDNI" CssClass="style106" ErrorMessage="Ingrese DNI Valido" 
                        ForeColor="Red" MaximumValue="99999999" MinimumValue="11111111" 
                        SetFocusOnError="True" Type="Double" ValidationGroup="1" 
                        ViewStateMode="Disabled"></asp:RangeValidator>
                    <asp:RequiredFieldValidator ID="RequiredFieldValidator10" runat="server" 
                        ControlToValidate="TBNroDNI" CssClass="style117" ErrorMessage="*" 
                        ForeColor="Red" ValidationGroup="2"></asp:RequiredFieldValidator>
                    <b>
                    <asp:RequiredFieldValidator ID="RequiredFieldValidator11" runat="server" 
                        ControlToValidate="TBApellido" CssClass="style119" ErrorMessage="*" 
                        ForeColor="Red" ValidationGroup="2"></asp:RequiredFieldValidator>
                    <asp:RequiredFieldValidator ID="RequiredFieldValidator12" runat="server" 
                        ControlToValidate="TBNombre" CssClass="style118" ErrorMessage="*" 
                        ForeColor="Red" ValidationGroup="2"></asp:RequiredFieldValidator>
                    <asp:RequiredFieldValidator ID="RequiredFieldValidator13" runat="server" 
                        ControlToValidate="TBNroTelefono" CssClass="style121" ErrorMessage="*" 
                        ForeColor="Red" ValidationGroup="2"></asp:RequiredFieldValidator>
                    </b>
    </asp:Panel>
       </b>
   
                     <span class="style5">
                 <asp:Label ID="Label6" runat="server" Text="Label" Visible="False"></asp:Label>
    </span>
   
        <asp:SqlDataSource ID="DSBarrio" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
            SelectCommand="SELECT * FROM [T_Barrio]" 
         ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>"></asp:SqlDataSource>
        <asp:SqlDataSource ID="DSLocalidad" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
            SelectCommand="SELECT * FROM [T_Localidad]" 
         ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>"></asp:SqlDataSource>
        <asp:SqlDataSource ID="DSProvincia" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
            SelectCommand="SELECT * FROM [T_Provincia]" 
         ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>"></asp:SqlDataSource>
        <asp:SqlDataSource ID="DSTipoTel" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
            SelectCommand="SELECT * FROM [T_TipoTelefono] where habilitado&gt;0"></asp:SqlDataSource>
        <asp:SqlDataSource ID="DSTipoDoc" runat="server" 
         ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
         SelectCommand="SELECT * FROM [T_TipoDoc]" 
         ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>"></asp:SqlDataSource>
     <asp:SqlDataSource ID="DSEmpleados" runat="server" 
         ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
         
         InsertCommand="INSERT INTO T_Empleado(fechaIngreso, idCargo, numDocumento, nombre, apellido, idTipoDocumento, dirCorreo, idTipoTelefono, numTelefono, fechaNacimiento, calle, observaciones, numeroCalle, piso, departamento, codPostal, idBarrio, idLocalidad, idProvincia, idPais, estado) VALUES (@fechaIngreso, @idCargo, @numDocumento, @nombre, @apellido, @idTipoDocumento, @dirCorreo, @idTipoTelefono, @numTelefono, @fechaNacimiento, @calle, @observaciones, @numeroCalle, @piso, @departamento, @codPostal, @idBarrio, @idLocalidad, @idProvincia, @idPais, @estado)" 
         
         
         
         
         
         
         
         SelectCommand="SELECT legajo, fechaIngreso, idCargo, numDocumento, nombre, apellido, idTipoDocumento, dirCorreo, idTipoTelefono, numTelefono, fechaNacimiento, observaciones, calle, numeroCalle, piso, departamento, codPostal, idBarrio, idLocalidad, idProvincia, idPais, estado FROM T_Empleado WHERE (numDocumento = @numDocumento)" UpdateCommand="UPDATE T_Empleado SET  idCargo = @idCargo, numDocumento = @numDocumento, nombre = @nombre, apellido = @apellido, idTipoDocumento = @idTipoDocumento, dirCorreo = @dirCorreo, idTipoTelefono = @idTipoTelefono, numTelefono = @numTelefono, fechaNacimiento = @fechaNacimiento, observaciones = @observaciones, calle = @calle, numeroCalle = @numeroCalle, piso = @piso, departamento = @departamento, codPostal = @codPostal, idBarrio = @idBarrio, idLocalidad = @idLocalidad, idPais = @idPais, idProvincia = @idProvincia, estado = @estado WHERE (numDocumento = @numDocumento)" 
         ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>">
         <InsertParameters>
             <asp:Parameter Name="fechaIngreso" />
             <asp:Parameter Name="idCargo" />
             <asp:Parameter Name="numDocumento" />
             <asp:Parameter Name="nombre" />
             <asp:Parameter Name="apellido" />
             <asp:Parameter Name="idTipoDocumento" />
             <asp:Parameter Name="dirCorreo" />
             <asp:Parameter Name="idTipoTelefono" />
             <asp:Parameter Name="numTelefono" />
             <asp:Parameter Name="fechaNacimiento" />
             <asp:Parameter Name="calle" />
             <asp:Parameter Name="observaciones" />
             <asp:Parameter Name="numeroCalle" />
             <asp:Parameter Name="piso" />
             <asp:Parameter Name="departamento" />
             <asp:Parameter Name="codPostal" />
             <asp:Parameter Name="idBarrio" />
             <asp:Parameter Name="idLocalidad" />
             <asp:Parameter Name="idProvincia" />
             <asp:Parameter Name="idPais" />
             <asp:Parameter Name="estado" />
         </InsertParameters>
         <SelectParameters>
             <asp:Parameter Name="numDocumento" />
         </SelectParameters>
         <UpdateParameters>
             <asp:Parameter Name="idCargo" />
             <asp:Parameter Name="numDocumento" />
             <asp:Parameter Name="nombre" />
             <asp:Parameter Name="apellido" />
             <asp:Parameter Name="idTipoDocumento" />
             <asp:Parameter Name="dirCorreo" />
             <asp:Parameter Name="idTipoTelefono" />
             <asp:Parameter Name="numTelefono" />
             <asp:Parameter Name="fechaNacimiento" />
             <asp:Parameter Name="observaciones" />
             <asp:Parameter Name="calle" />
             <asp:Parameter Name="numeroCalle" />
             <asp:Parameter Name="piso" />
             <asp:Parameter Name="departamento" />
             <asp:Parameter Name="codPostal" />
             <asp:Parameter Name="idBarrio" />
             <asp:Parameter Name="idLocalidad" />
             <asp:Parameter Name="idPais" />
             <asp:Parameter Name="idProvincia" />
             <asp:Parameter Name="estado" />
         </UpdateParameters>
     </asp:SqlDataSource>
     <asp:SqlDataSource ID="DSCargo" runat="server" 
         ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
         SelectCommand="SELECT * FROM [T_Cargo] where habilitado &gt; 0"></asp:SqlDataSource>
     <asp:SqlDataSource ID="DSEmpleados2" runat="server" 
         ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
         ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
         SelectCommand="SELECT T_Empleado.* FROM T_Empleado"></asp:SqlDataSource>
     <asp:SqlDataSource ID="DSEmpleados3" runat="server" 
         ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
         ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
         SelectCommand="SELECT numDocumento, legajo FROM T_Empleado WHERE (numDocumento = @numDocumento)">
         <SelectParameters>
             <asp:Parameter Name="numDocumento" />
         </SelectParameters>
     </asp:SqlDataSource>
                    
                     <strong>
                     <asp:Label ID="Label7" runat="server" Visible="False"></asp:Label>
                     <span class="style5">
    <asp:Label ID="Label1" runat="server" CssClass="style5" Font-Bold="True" 
         Visible="False"></asp:Label>
     
                     </span>
                     </strong>
                    
     <br />
</asp:Content>

